How to: Insert a page number on a worksheet.
Solution:
Select the worksheet. Insert the page number as a header or footer using 'Page Setup...' in the 'File' menu.
1) Select the desired worksheet.
2) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
3) Click 'Header/Footer' tab.
4) Select the desired page number format from the 'Header' or the 'Footer' drop-down list.
Selecting page number format
5) Click 'OK'.
